SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445066 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445066 [ RunTime:0.001432s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466106,584310,600231,131793,937784,679394,801043,951664,805752,713449,344835,1029749,1039859,432398,281562,243750,629445,961399,492862,533234,617798,304234,467576,856910,641208,888705,270336,206249,858170,96649,732302,545940,711070,821614,857609,928007,271227,680320,569143,64880,944541,122723,912592,300137,818980,98468,939672,752082,313313,681734,953789,196468,340738,301712,534304,229499,691942,1027819,1025847,518724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004621s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445066 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000624s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445066 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]