SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001471s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311552 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311552 [ RunTime:0.005915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406614,186211,718208,969563,156318,337166,929528,937158,117167,606704,196668,234614,866653,45753,149059,350731,57975,755414,410676,543995,878472,43140,591299,602641,764026,372493,649003,859492,345564,300111,13669,1046298,731540,206319,575192,607472,608262,876102,106717,143561,533822,568924,1000530,879888,523350,362418,1044983,722758,461375,14565,811743,311937,290302,769598,372201,776773,258141,739416,415266,832317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311552 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311552 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]