SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001426s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 951948 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 951948 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393897,152536,381198,211741,604163,354471,844303,1046663,459048,1002125,556257,388370,446159,790078,926416,96309,834513,925936,882298,836985,680554,81275,578355,135381,991719,1000464,189431,778268,319630,668044,876672,640566,737135,361659,326954,579583,929036,366114,534048,528238,355539,54772,74843,363308,1039950,632417,587653,806508,138631,280710,742936,309795,243944,382189,476782,942742,687932,253759,748147,598557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 951948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 951948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003230s ]