SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001678s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801210 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801210 [ RunTime:0.001392s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588576,154396,500595,688510,864447,838942,185414,456294,788696,279856,21843,923415,900044,387107,390935,223407,747310,712887,940709,105098,399988,130477,980825,1004602,919099,920425,207954,1014003,681410,84092,370334,617003,894720,552986,675164,233119,293530,295707,305082,1014669,94556,776543,115783,257034,33856,6330,938499,1029159,237222,722792,1023359,894647,768604,570925,115991,399545,458236,80786,753859,979413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]