SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502413 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502413 [ RunTime:0.002412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41716,227430,846304,397140,480183,945068,434306,824300,249550,415454,285154,354394,810941,1036088,789709,501337,486913,26219,967197,697382,754295,412842,10793,371589,102284,993562,811374,1046200,632581,481187,936200,815742,588060,809275,267333,234299,246400,383901,636545,528658,559197,869656,644176,116853,770756,296473,125175,654566,184222,222581,480920,1022458,54008,492959,155688,397274,562314,295567,743588,1043988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001814s ]