SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001787s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101753 LIMIT 1 [ RunTime:0.000909s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101753 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (866837,1010366,34433,555850,824810,1032140,759705,608765,434141,267754,42001,466695,173073,478961,811912,371348,443900,818915,727655,699590,729096,395977,941148,464739,859730,315748,244386,572867,761105,602656,246804,514634,749756,940059,395468,565656,422531,905430,843652,188673,155583,142876,49580,366590,630839,708060,857385,77535,640888,822513,675176,800897,609865,980600,947310,422176,797742,743742,642350,339959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]