SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434776 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434776 [ RunTime:0.002118s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591331,549795,680961,156168,556130,591274,31869,521884,872806,852507,1047891,57346,986658,724945,177880,681506,118985,238045,477561,813830,155360,950508,185209,56441,284724,275680,572008,580578,651393,640505,992228,133285,928508,781808,517405,3350,1029190,1024689,583067,486457,412907,1048225,397355,542958,657819,794168,18473,983162,165208,202666,551476,845747,734412,1048177,911774,956109,539769,501075,236890,933550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001730s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434776 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434776 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]