SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460416 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460416 [ RunTime:0.002107s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6227,250499,772829,455723,68007,719075,624976,965050,98284,844583,80498,645556,61885,34851,158923,903611,178019,280397,330326,429369,989058,56130,21316,749094,945822,226862,508256,7867,341524,93,245983,601116,781421,885357,275725,464297,704990,222123,815211,379615,991809,876034,2008,67502,221276,377208,744012,387864,340214,244552,70828,760393,184923,131778,1005342,538053,627656,612531,866788,366226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001018s ]