SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 86180 LIMIT 1 [ RunTime:0.002561s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 86180 [ RunTime:0.002059s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221714,299044,358088,716100,570620,63103,976219,338782,494098,55815,351636,292545,556871,904085,36010,234626,280418,229345,183270,151885,87660,430152,425782,303612,189288,26772,292415,484722,132653,241936,163348,151064,1005010,207205,126814,713571,121842,504460,834147,592785,682285,1007950,1033040,297506,984688,1020066,134349,240641,829148,199855,292759,725174,944064,396076,616965,968076,931929,979601,661688,968968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 86180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 86180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]