SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105086 LIMIT 1 [ RunTime:0.000267s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105086 [ RunTime:0.004147s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15087,280629,642215,691138,315087,1015918,497018,932897,826608,234337,174885,132150,830534,860665,955920,184456,539498,665950,821993,67196,781332,162632,866087,692410,485785,804407,271484,1000084,544935,23506,448194,606251,637050,219944,276732,590833,727649,1048621,562480,965537,698037,100823,640109,453351,114657,426676,404726,695109,35672,461429,133014,644222,1022605,119361,22651,67430,731633,101317,482785,532838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105086 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105086 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]