SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381243 LIMIT 1 [ RunTime:0.000838s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381243 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183530,368232,79591,300858,366856,187872,473885,40959,803057,915576,899950,1033001,128152,526132,942997,514858,719003,76719,835144,49507,250290,973054,476587,1029621,888641,914191,1039294,167451,860896,283852,62938,346859,440791,97646,237375,793535,285653,938017,471384,423438,238288,789296,1020964,851288,802337,22865,175610,651716,555273,161500,739767,687923,746338,431854,465586,1030706,505183,276516,740274,328138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]