SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001756s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501718 LIMIT 1 [ RunTime:0.000826s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501718 [ RunTime:0.002473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55516,137788,279564,405931,777037,845849,583699,927141,301606,773788,84445,818097,721953,427728,995175,119761,420840,755571,330492,391710,684187,458308,600988,833259,304932,267519,474162,127009,425232,441791,707847,803961,470854,951304,1032020,249192,55389,47337,315274,633799,162667,879777,56805,25575,15525,392418,538546,247228,220482,459940,529648,18310,699163,1039354,630944,234934,660932,731967,340741,920517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004132s ]