SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420442 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420442 [ RunTime:0.001873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692861,654888,79730,443249,833923,648911,484243,528424,68113,110150,503523,31792,28287,209811,293196,389464,997787,608719,272644,344415,302878,985912,245447,341866,1047929,1045813,34013,436716,259562,1039736,3639,474926,420992,516808,648664,872356,285886,181435,188658,538587,480949,655008,719691,86017,73998,128995,697065,521518,1009151,780289,986931,530503,845336,384256,371697,586974,346987,412059,679229,1005670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]