SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394815 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394815 [ RunTime:0.002257s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19947,188070,352568,319442,331371,600527,1007505,53648,260830,557718,322539,256439,968725,188004,918284,70021,833367,514196,845366,622033,386400,707838,158314,12369,171253,440889,319784,449955,417738,285817,613351,725760,427181,33333,858,109250,939853,154993,786786,975763,187525,874542,490296,741544,320126,436116,244024,400845,456244,598553,126241,862921,957049,976052,716044,698087,106933,160838,356837,562363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]