SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004099 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004099 [ RunTime:0.002872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (882701,752820,374284,750466,991348,868972,963274,657263,908870,389439,946331,309911,333288,209060,2116,161606,728823,729445,1008054,679243,680319,227185,1007580,1028869,413623,113951,513854,66513,456747,160302,962286,287421,810944,454140,189102,395389,1044667,797622,620323,697228,1007851,387503,269067,355627,42756,550113,539655,462905,120689,607004,1047511,935370,335612,123981,728676,263530,539911,812092,177198,1017018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]