SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001892s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 184481 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 184481 [ RunTime:0.002480s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (735086,284834,194443,979310,365788,866997,467735,814141,522439,193695,312018,491363,473236,194332,330971,659691,75108,18158,391138,734020,145430,11321,36846,30634,1033783,988456,712505,956442,346309,301749,1044097,1029283,585190,190095,303524,884579,324775,133834,469863,729655,653607,250918,149986,196187,632605,711449,1045920,551860,105103,127816,916544,56410,137219,372285,1009873,35704,624975,227732,27773,467364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 184481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 184481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]