SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026168 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026168 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (700386,178041,982428,247116,488725,494166,149448,969075,514123,599308,952863,821405,643815,126635,39792,251706,891472,990387,247619,19694,238880,617722,120396,776108,773737,32866,101796,815202,123966,516974,305623,110487,117939,619381,580919,167383,49680,46907,133487,436212,997237,998766,690290,636549,957364,669720,943962,45038,727734,985338,576789,688380,596557,763272,605225,710629,550138,438774,927633,1041050) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026168 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026168 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]