SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468238 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468238 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66655,225684,985944,263740,1027208,979938,417155,85187,704740,453614,4519,778833,318633,285513,901862,18603,536128,929646,235969,663747,581347,616775,54960,641639,71233,736423,678627,572421,903663,441323,148727,934006,332471,800605,216268,368646,664706,217555,721783,994417,708507,767802,473156,1020561,1015161,823937,111151,959969,105044,47277,613585,385347,318006,1045102,442951,261678,42572,895975,492860,866333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000367s ]