SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349043 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349043 [ RunTime:0.002487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492596,506298,502880,805024,413367,665307,270546,276403,542216,45850,920685,427189,1000670,636580,439252,848125,385719,15399,789035,163624,844956,884595,589756,148810,295827,112465,32435,431941,673360,949652,38193,182701,306277,297601,520682,547754,631985,567099,204580,961590,12423,43642,111976,1020774,195645,978649,431861,733313,314896,545985,539296,729611,321733,482386,444162,446354,849825,730034,450677,158050) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001220s ]