SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110384 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110384 [ RunTime:0.001515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117223,612508,701108,501310,606815,38259,859558,330824,819744,651584,110634,661999,1028092,920036,554205,348416,267892,354785,955672,807259,216486,222811,34126,538087,101942,549517,331981,1028367,108343,204365,32571,228295,971445,971533,494198,1033847,965444,1010668,999759,276939,24069,333592,881222,248115,264310,586742,99190,793592,553854,411178,888080,419584,410660,771190,230349,391687,1026554,422972,831740,543014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110384 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110384 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]