SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546623 LIMIT 1 [ RunTime:0.000503s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546623 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399047,24813,797344,318060,702573,794757,625176,757013,32222,546120,577250,1042811,894485,634653,237593,783658,269693,627797,266360,372368,451119,1010084,731193,985526,537487,229809,825058,1045671,1031888,768000,93439,68116,545272,389828,335428,557160,829860,775925,66893,15501,773429,368133,648538,325976,195576,542365,973754,785215,880784,800832,285793,715766,448943,791725,69501,811133,196165,1044984,751122,709065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]