SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 961728 LIMIT 1 [ RunTime:0.000552s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 961728 [ RunTime:0.003318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (241010,892656,326981,242047,942962,673511,116767,37201,731571,380709,865001,52269,966782,861592,513325,705759,96016,563198,1047791,72326,368587,372608,490633,780979,807864,223524,289769,89017,770088,265878,246628,191317,229163,744122,523589,793504,132868,304964,494694,40011,845100,450140,904549,103711,981767,784580,557278,774484,381666,757120,913694,654117,740602,683180,183876,864020,976529,952340,224880,205502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 961728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 961728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]