SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48709 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48709 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656934,15450,335993,845010,1025989,747776,929517,844091,685407,65638,93510,981968,674018,468974,665828,222895,634637,741816,409967,261976,156353,19216,548055,722543,828822,590844,553997,186500,945163,628192,439855,472338,1038577,312374,249922,134031,640990,606364,262083,226816,54892,452245,153305,23506,400796,576116,556626,393504,508747,137609,822350,258866,1010123,211308,1024855,56144,510993,416195,834802,383730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48709 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48709 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]