SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511951 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511951 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871823,226023,754261,692413,99187,72624,609937,1040025,853013,1048068,724747,923271,217388,567731,567768,33691,74671,273688,849331,920239,485685,1046538,698907,945873,626819,688984,437440,119949,595863,814717,232801,677076,487727,443857,532966,779868,859454,672068,66671,731585,1027232,872970,731655,900747,580315,677876,374973,499243,961816,979188,510715,14371,836566,419779,281298,127354,145475,25392,567321,828157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]