SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456276 LIMIT 1 [ RunTime:0.000285s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456276 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (961404,990025,50939,59824,428646,856203,613668,214673,256835,336798,354174,516891,529790,950851,919031,1001739,649733,149526,848550,80162,17873,552,125976,1047721,939358,812398,66980,263407,75359,202052,78344,688306,775050,225126,163016,881092,432417,231496,1020178,711322,732012,340755,680732,685288,982671,861339,517604,505123,400702,686219,199836,81254,151081,872513,741907,708928,637837,359180,722787,502636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]