SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001499s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030201 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030201 [ RunTime:0.003811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130234,491439,491377,190871,489601,188077,129650,34819,547718,177963,843021,507937,502169,209894,355362,160510,758107,951206,135101,127932,312871,892039,418882,575379,665563,1046457,463644,928932,576852,200798,448109,769869,624171,606489,494773,698626,370935,198916,401817,675421,381012,300331,928725,727045,418692,417044,54774,146621,1006390,829532,269969,527638,57725,10789,31763,283433,453414,168959,686234,756146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000731s ]