SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482808 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482808 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270125,991784,643045,744922,892987,25716,196667,184009,575790,642523,294017,51490,706823,904604,1023887,623208,425551,870679,231485,942670,297388,292667,332229,91397,747856,822671,768446,852865,128865,758896,104699,808659,377795,169788,577941,653190,355465,1036329,273227,537869,24490,927168,831167,475614,785742,548174,912198,458570,1010381,265444,986467,22705,878585,236329,813450,200205,697940,588782,310844,829658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]