SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 711753 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 711753 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416411,351354,874419,687366,523337,271198,726795,404968,212572,858889,39838,820520,850947,623450,646111,507503,611095,580945,711745,276135,838489,530323,880543,706780,174952,77005,995300,438306,780049,1024656,953094,545425,1022390,623154,786275,536337,490957,835567,140132,1017924,817096,132461,694362,1007439,101480,185717,948163,898169,889425,265736,769945,341652,871286,866721,989279,68416,72983,278215,319818,604037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 711753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 711753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]