SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001688s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496457 LIMIT 1 [ RunTime:0.001595s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496457 [ RunTime:0.002681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608733,593908,729058,441976,482917,100576,643068,441225,488729,589805,472738,580036,283109,908056,860221,119879,285227,894780,387659,6401,673303,489363,418617,45866,874727,123477,620097,242966,498839,92325,462490,365021,481227,626259,638387,864326,244928,622722,996522,670015,455040,610508,846070,238583,112770,90155,755398,24429,525582,542221,637311,256986,715820,642470,889038,939066,377172,481020,77363,308048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]