SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039821 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039821 [ RunTime:0.002198s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932269,319897,771417,948741,524533,923001,839282,73543,869097,492861,268147,204262,767682,307305,696592,212886,507692,1003486,945843,128311,566648,365568,615891,50812,339318,727107,54832,492474,822152,1030129,818252,106803,807064,635661,219676,802848,589391,622233,786836,597467,699196,357735,804773,611040,754666,349316,334913,42867,1030649,1027621,702538,136985,295433,196929,355009,523110,378876,553178,639398,211455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001738s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]