SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021051 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021051 [ RunTime:0.002232s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (948034,961708,357080,509556,555176,420056,375595,362455,129063,459839,1020955,396161,88145,815948,1048427,880677,1029921,60205,587863,868564,193348,100547,122087,716162,313926,811712,959170,50740,212351,328876,477524,98052,835092,738670,548092,917686,450336,143796,263472,244682,926094,88500,301398,754147,850295,16490,1010165,996446,206259,342816,357955,251411,418223,900022,398682,758733,939773,98986,724485,571583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]