SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804807 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804807 [ RunTime:0.001875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (272044,969669,43650,845292,595723,586525,169287,171689,222356,944064,1018927,562703,209294,571511,522680,613570,578976,846824,528896,804846,194977,406848,807839,123458,190244,785941,1019492,208792,177287,180779,267392,1007965,680448,522762,321200,962942,208327,510002,665888,486868,928082,954725,645848,1001482,447264,406511,521400,642959,135829,886698,18050,553476,422414,933594,392037,848428,830292,837808,789559,592903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]