SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547251 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547251 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710785,681768,465319,154812,1020400,317692,849562,493175,666153,786857,245653,97838,973917,552293,760842,950086,360463,802559,168184,516266,660163,264521,286972,353670,777247,250936,162358,613767,513526,138925,710577,162441,91815,895274,611941,438313,574344,727701,969808,981111,1016755,214708,498844,355142,287519,572402,659353,670554,813937,304427,1007775,157218,891445,701068,462577,201509,642040,724793,117788,599814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002872s ]