SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 9822 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 9822 [ RunTime:0.002953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54522,50384,415431,172812,690830,496489,478517,1007938,752760,177100,633947,345251,142384,170903,984727,581879,759473,683832,834390,501670,201788,78890,369189,538267,712864,180796,831519,666982,834279,681631,856154,167126,421468,585390,73892,641009,442090,491839,945054,515368,586607,240602,996032,813066,175682,142188,997387,38653,892896,183706,369857,258038,363755,574872,201882,235217,275680,807223,1000897,218449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 9822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 9822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000736s ]