SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 298407 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 298407 [ RunTime:0.002407s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486991,905750,82283,90257,675022,364073,409157,982034,682392,740579,459437,286551,640937,885313,380673,675860,476319,104907,465085,79214,626545,547709,495779,422093,935478,309832,134243,110007,263833,879049,588224,996533,391000,717423,126098,530398,649286,1028575,1005422,776222,486985,124827,869223,635731,677255,780423,401300,309965,533581,176052,577404,120308,590806,441270,696574,1001537,828090,423242,484956,932529) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 298407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 298407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]