SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001688s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543523 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543523 [ RunTime:0.003002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287696,749579,738814,133744,945440,237577,552855,62986,294085,179469,309972,272628,938148,652395,63767,299743,680111,681759,686161,163542,698239,896694,610698,1002591,29560,546308,944649,974149,393422,532580,940788,839475,235208,867644,59324,923023,239695,544480,126385,616126,925054,304994,341923,228634,210897,925601,805282,1004646,750940,277947,277923,660947,763954,386052,857000,879317,143558,388771,1003657,422687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001104s ]