SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543016 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543016 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358138,309024,141404,861836,862911,763416,465457,315535,394059,343514,833587,742830,452832,254112,652321,1042149,294289,139529,806044,229383,937070,318990,270314,664332,200202,672834,406367,821396,149014,900268,952331,443704,780163,472053,321798,380347,767324,851765,41527,604686,1045418,358216,919365,563767,858365,197483,577944,634721,648800,17450,387683,214720,83037,9529,549412,649832,518059,792396,178024,849087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]