SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527240 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527240 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494125,911043,769628,255598,1023783,973855,996113,887652,837038,599888,305848,213956,795076,136950,119730,794407,800368,49911,54293,780104,336079,325528,556389,1012922,851068,204278,1022665,212019,255857,206447,509276,678134,560118,392574,902161,207086,766996,689350,346744,656,543567,190218,674943,728232,254608,807426,311923,265490,965687,541532,193968,236977,731315,655543,550885,606516,1040399,394465,71648,447621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]