SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449078 LIMIT 1 [ RunTime:0.000576s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449078 [ RunTime:0.001442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207379,565565,713780,1012885,702205,247406,772102,376937,156256,300693,662074,788207,209494,180128,606051,424305,696166,688421,202191,962884,811485,17740,393398,567719,173823,150005,890170,727889,780534,308818,363863,100632,707566,556422,882216,206086,642204,481117,669646,651501,92940,152538,114579,71543,737394,170621,710867,1014271,595693,574500,503732,296434,828541,819847,871004,139543,484649,859706,141913,867112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]