SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449883 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449883 [ RunTime:0.003019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (8294,252440,332976,824795,1031023,1000670,453307,770311,545516,900732,294854,61386,806233,755745,898090,491174,96960,819718,786729,54591,399463,500730,258913,985265,193281,1034302,322949,271597,47275,995442,482608,603272,437493,750040,554071,132428,40890,336196,92904,385704,772013,771885,19471,575989,930789,48073,948759,485039,464460,158400,675138,710795,869573,284224,725724,223620,919130,916998,316573,919578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002885s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]