SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465643 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465643 [ RunTime:0.001955s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14931,121937,501906,62198,151378,460631,747242,706403,462057,402394,394855,34508,16917,426541,1010034,939895,341761,773225,1004678,252194,347425,687975,338568,42298,938957,924565,930116,800963,980702,238924,695424,7157,769384,956362,934623,262677,44840,990419,267565,560753,863827,234225,897961,105568,861562,957796,971910,694833,1025397,434575,234473,556905,986939,620734,932886,454654,957174,383329,813697,489816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]