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` = 511438 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511438 [ RunTime:0.002101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257721,33558,401916,226984,365143,664074,235976,1029364,581255,443504,720660,918587,304248,1004965,730240,223530,453847,994107,115745,981725,684689,438596,595746,283682,1017593,866754,915360,960526,7039,647589,988708,903951,797108,397898,552388,606892,152109,528466,925281,1823,67382,32032,14305,1047053,452629,826313,661339,72149,579412,793612,684696,301996,120210,337584,108059,201630,985929,705386,743197,699155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]