SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485681 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485681 [ RunTime:0.001504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (891215,537311,664783,434782,772404,895412,514852,10382,930484,142766,716204,912649,742897,439978,666042,223328,66926,10546,465766,10777,403373,459967,18042,593028,1002849,784787,1009988,228855,444861,905314,86965,83450,737162,138513,975689,630318,595239,174167,938265,300505,572589,981906,816897,330798,724539,776807,886025,966367,1030773,469232,74525,6765,567250,63,597148,986173,676535,9691,982291,617226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]