SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001578s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341012 LIMIT 1 [ RunTime:0.000497s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341012 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022823,948305,271618,98151,82956,178376,878649,730466,230202,563007,498829,29377,814732,574228,416377,528048,425743,610113,1001506,518921,450186,1244,263363,699569,969211,629250,925858,676978,826717,24715,946989,760617,915135,475707,603392,314042,1004668,993244,174807,1040339,414933,216203,453648,152556,474349,70841,536246,231202,799074,549407,741749,634884,282908,1036920,105572,549859,313461,746355,876252,291650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]