SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567581 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567581 [ RunTime:0.002052s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197602,566421,867950,872460,364207,77862,770446,932608,694823,916146,389685,239020,491008,84702,442642,1012065,919536,386024,319144,783101,569526,316841,661778,651127,806014,314824,588561,394461,138143,800519,7587,977841,698215,831926,849841,849014,169555,584206,188194,218698,879428,397624,959875,375891,105271,740949,120884,211372,331026,794976,620807,625875,996361,714968,123916,331971,627426,366362,360368,639614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001277s ]