SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046778 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046778 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644045,43348,382625,357514,293650,1022433,184225,932727,94181,841689,848550,991954,559256,77850,637636,921203,583552,1046054,332603,110193,543930,831050,502508,826413,910873,61353,696932,228160,446614,283429,148710,358189,403337,269796,109404,914192,713087,579018,51212,44190,119737,656133,200652,1041385,276367,749171,1042086,240928,652415,566923,699834,377855,351376,587778,464808,347429,1025307,513560,816737,89393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046778 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046778 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]