SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343320 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343320 [ RunTime:0.002064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681832,219907,525269,730241,849285,682505,118761,924550,291542,395873,356414,1016001,833095,885528,105706,626103,314476,48958,783730,422909,141857,999856,934039,287529,684365,1003345,577744,357407,229857,438531,928724,153109,27229,1010190,646197,920270,890271,888764,441615,632681,28647,777169,351618,898018,726480,271147,621850,329206,603450,149152,350018,880640,63239,505691,380538,283220,974984,616373,539584,354626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]