SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4243 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4243 [ RunTime:0.004430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24410,178443,285655,427466,655616,381391,714025,775204,883720,735248,720806,181481,996202,203664,885544,509288,968126,1042817,441500,1008346,387558,719969,632171,824876,268924,98259,830891,844404,552609,396384,604594,693107,420438,642953,571975,131161,197100,73579,6619,546921,847415,492824,521676,384512,108169,149052,978743,778114,757409,586828,599783,77665,642248,666337,328438,841360,1007814,39828,673316,576102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001829s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003779s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]