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` = 565181 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565181 [ RunTime:0.002451s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108777,331374,561541,538204,485594,714587,169161,992722,215065,524995,946501,726699,974858,654903,337181,385808,342721,732906,870190,581929,419208,500764,710053,41019,625302,102726,694134,963461,204707,486855,427360,308978,223967,93080,307891,133375,134631,338896,747588,68232,853687,802048,576496,75718,125261,709582,604299,679414,857399,408468,340951,897264,510583,770238,252873,380611,1015861,184076,244625,501261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]