SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031765 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031765 [ RunTime:0.001888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564990,5121,778034,329908,499498,455059,689756,940876,435389,180106,51117,608573,232138,1002112,53340,103926,38874,850092,767118,455401,817322,450554,433788,545974,510134,713853,575001,852884,500021,723686,737663,685296,22379,678501,67415,686982,990507,831959,40750,577232,750421,293766,995851,297452,937280,583205,409590,473079,905220,924615,696161,528487,420631,198822,457989,510865,590295,707342,746377,733963) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031765 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031765 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001470s ]