SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30508 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30508 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645593,337119,343716,527875,359898,447939,920685,965346,287287,276766,709150,463680,235526,225471,481507,646212,1002275,499016,575735,595396,2771,98057,232666,598999,351221,685486,517228,578385,992340,695780,196993,992949,420053,693211,56365,651276,145123,324589,114514,146327,330856,930991,381279,290779,401032,307759,660059,104374,130721,1038803,349691,367044,1025385,1027546,524441,501547,227348,370576,630111,852828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003645s ]