SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545007 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545007 [ RunTime:0.002017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443261,515204,694489,659300,621181,542438,88935,691104,933854,555366,690300,428221,403270,574521,703980,348998,786389,1041581,878283,666060,839706,26450,903299,626345,380901,53188,757614,317208,311243,244657,918378,772461,277765,475160,665650,305175,990853,81037,304084,489472,274546,203542,355133,418485,804727,396626,968610,994390,236197,441431,227897,587530,120079,836045,358850,847029,605338,395494,686419,828862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545007 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545007 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]