SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503619 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503619 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413582,528221,813314,783481,801208,951923,81307,325397,433327,809438,311321,847016,413167,396824,976955,396867,342977,390432,1001258,919080,746945,600015,568345,1041472,513143,640374,896842,119951,82622,400859,381592,1013533,575215,697069,11896,208034,468945,59583,11970,314678,4521,224624,198305,680462,393294,797724,953125,454041,259143,350545,87361,1017138,865648,330732,813070,72598,596087,494075,812821,796796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503619 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503619 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]