SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505931 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505931 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214962,334888,365790,44550,917971,308717,85083,202099,487864,679133,1005586,749879,507189,420014,281469,138369,168389,842679,297208,199825,595234,626585,429909,850720,60092,524503,743671,151614,1006113,463907,277490,1036124,286010,1006693,451561,646561,237390,213252,768958,614916,714857,713748,165678,264714,197501,674681,723912,234492,560701,709195,991929,328139,62489,967549,159801,215894,890796,408657,300267,531676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]