SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411240 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411240 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (639512,943314,249023,750636,249205,680467,1030479,989047,398327,190011,516336,468390,723496,626874,368872,808403,264676,903693,133018,432183,119405,376772,44033,133888,817276,236892,944215,248389,693325,686226,954926,387676,350522,652481,585650,1047298,545025,450096,104578,874906,939311,960244,48303,337421,329071,620405,905210,422470,678842,660521,899894,500990,1038367,848687,961426,410744,186043,1010586,281022,731842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000761s ]