SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540807 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540807 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556056,874746,974442,617542,477743,476154,483588,407105,1037765,775836,144101,551243,1026142,617545,211324,631925,883417,28453,332469,724900,606750,492416,659823,724587,211782,936338,129963,280977,271480,397929,315143,448870,397761,32792,663447,738925,631242,806738,895509,341891,574462,553965,873964,514468,150520,800844,597787,364454,323888,844142,1034782,896006,88553,97632,567557,143420,990756,828582,965683,166847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]