SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535844 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535844 [ RunTime:0.002867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334441,477541,401586,634168,1044692,30900,761738,339906,755460,860121,838492,395530,316596,310070,133858,106009,73398,1023245,96130,178108,742416,682456,424848,793136,115856,373702,493264,230001,103726,916557,986107,482181,381967,219686,225329,490913,30342,2176,165637,544846,246619,181640,546769,431976,1000449,759153,289934,977825,921963,822854,904096,27275,754374,830803,865037,365719,906396,740745,755296,752634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]