SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423631 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423631 [ RunTime:0.001330s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177782,359795,564218,420800,11513,748386,1010380,946973,457452,233218,461840,772639,17626,67822,341800,310750,306238,741341,7929,953473,322194,582121,450219,635418,823048,523887,257333,123591,137468,61420,289147,393082,316503,912992,488908,600411,839655,603971,1000927,423281,752589,239050,819080,1037514,821450,711292,844253,68662,235224,689470,994004,105115,341541,576578,448198,963718,371442,87071,202087,464290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001885s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001116s ]