SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394570 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394570 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526023,619340,55804,636694,508263,63977,983217,662585,352470,830468,724085,94841,1028647,632589,579626,357297,823591,135704,380628,1028029,993578,921647,92378,168333,685804,799492,807803,933891,374783,267249,335441,600280,260771,556114,945114,263793,344252,441373,219031,423088,152091,648262,1003544,673577,808473,346576,1021499,1034107,319699,954318,956823,780813,383762,553943,57881,273364,831071,274117,607180,96528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000728s ]