SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516912 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516912 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932392,922242,967504,186506,360113,971730,233584,2714,813271,35627,597927,626574,1621,577671,653663,779863,795990,1042933,942599,503130,670179,463897,1042023,139468,491170,234571,770210,762914,936149,310455,582878,483789,46139,299688,611463,941883,430747,714291,69928,191907,584660,870937,862295,363190,228873,617019,658125,107218,30894,4083,722045,1017812,1023102,970550,454119,71602,600011,525673,174535,983966) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]