SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586846 LIMIT 1 [ RunTime:0.000875s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586846 [ RunTime:0.005030s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212163,287785,165097,692936,389146,939880,972038,757784,429701,774747,629880,669413,104212,33672,839999,723163,320355,321560,193031,969500,762804,673934,371225,451829,867411,244853,598178,510811,752516,38357,879722,121703,974806,108856,66801,459938,241886,160343,85273,323129,50464,131343,251813,262076,407075,650566,155899,884338,342294,917508,810638,996879,724700,469792,149670,882380,654956,717093,572411,116377) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000822s ]