SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51405 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51405 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383036,397871,1021609,264667,122434,909221,1000805,556224,566637,825345,506047,233574,63528,232008,365726,844274,835250,503,842650,171615,169078,70461,744642,436476,564778,524101,934265,630522,149385,233324,674124,518105,441508,267331,573337,1044822,634125,66181,558968,240776,947906,486178,638614,140564,50534,578117,327159,124637,186569,692082,439175,600663,890681,455197,386735,952088,1003420,877723,929344,642742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]