SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002043s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003884 LIMIT 1 [ RunTime:0.000518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003884 [ RunTime:0.002070s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474392,772557,664468,148185,989646,754508,513795,952047,979845,96170,885875,154228,207188,446062,702396,1030113,1012725,898695,769396,460171,638934,137939,959512,83656,436261,635463,561863,969873,935853,80883,642556,619128,590226,34076,590442,835486,361172,477449,899482,267456,724524,921052,918792,272323,817442,598335,323692,385292,184418,505072,623179,739038,22836,231980,609424,593819,128134,82684,772066,163331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003884 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003884 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000759s ]