SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001607s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509225 LIMIT 1 [ RunTime:0.000615s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509225 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (997910,991360,532582,312562,58385,284105,860780,706358,450615,327317,474058,747205,817754,171368,844944,870705,1022061,204852,48405,868771,386551,55601,274571,582463,146351,96094,646430,77024,534672,862504,696485,946687,106465,844085,1029431,391236,794754,949989,61906,430268,139914,483796,27206,516223,942741,1041027,453578,677698,240098,925572,1011479,24176,68401,964061,852386,735811,412772,354574,957153,428307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509225 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509225 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]