SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 668100 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 668100 [ RunTime:0.002184s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047797,28443,355058,223450,497405,187686,782503,455592,786462,798005,178780,259187,784341,901955,72626,883204,126083,681589,526099,547231,48704,731330,825393,876353,505802,989985,748383,683600,954741,965072,90671,474398,788101,896543,826117,349901,361458,414709,370173,312238,709170,697894,914346,538767,241318,391766,753920,704066,803251,384398,551014,292894,881810,744663,770747,876151,293140,255961,145815,823199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 668100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 668100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001306s ]