SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520900 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520900 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (695606,696780,540164,878442,749848,729914,455491,888309,619067,795678,117648,63384,257203,112782,517585,850213,534170,1802,770339,389188,257797,345835,855030,227588,1018600,647581,955733,441100,1032545,118006,854324,118820,386788,13597,583804,231930,978871,16324,1048172,495807,753199,872072,992652,344290,1039560,228240,889645,580857,578701,178626,754948,643417,101492,452050,573543,141997,825395,1048189,461120,706229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001882s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520900 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520900 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]