SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502291 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502291 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706119,315196,359727,382730,277446,244365,801539,683084,213529,781936,155162,320593,225234,603464,702041,486787,567549,781314,253243,572477,239028,939558,190899,261437,325243,704555,725850,435264,619221,780799,897339,899338,575022,259470,243349,584737,110964,486657,574181,901377,636627,926013,876339,697171,890183,685277,475924,206923,16599,189853,646761,905107,19113,954441,10717,154765,155513,527355,299166,1003742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]