SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004598s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455336 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455336 [ RunTime:0.007947s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003476,796348,644680,598874,309778,396733,553330,464315,398440,423267,480993,665900,673271,108621,887252,895944,987572,731729,78417,1010879,504960,710253,722374,950521,681904,72865,591033,62989,741193,31380,248835,476664,28904,725824,533749,84930,629548,400400,534313,963309,894693,255478,183361,651496,532550,325675,537981,567663,423755,309133,954913,74208,983572,437261,827751,905498,60416,588902,898368,475111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001804s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455336 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455336 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000734s ]