SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513292 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513292 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28556,794188,741623,160225,915441,427113,51826,1044033,880562,910492,94995,299820,392112,776623,456414,599868,956789,773780,636339,872060,78931,567693,219431,691059,1038756,1018085,146429,105420,327557,941845,307695,139643,523521,796313,584107,122051,1047087,915535,835620,497928,221858,477784,544305,1039359,690168,636720,586124,329857,951692,785457,65175,739387,473201,857080,898375,522749,147560,364803,678526,8447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513292 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000709s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513292 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]