SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519104 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519104 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646141,766992,151436,1030123,929368,691771,128499,570140,36135,854787,867740,498519,808471,436359,580301,624705,1020428,839374,731251,975115,564713,749779,675243,603177,356239,697452,665215,657973,621772,643168,892166,792721,355245,405302,736303,523318,458524,205169,956563,741139,336221,165342,904714,437726,658020,479083,16488,388893,78079,601300,938716,228942,584230,803486,526222,865457,317258,622567,144674,841140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]