SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531806 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531806 [ RunTime:0.002973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18966,438660,157394,810416,1017359,420455,200230,466070,1020524,736916,432126,725352,95887,693764,1004980,474231,738175,468385,141130,974495,550718,115357,316375,232517,592252,451466,678755,136330,152713,578481,1016646,175774,233462,298737,654003,614337,1048209,750660,808164,1034784,634235,487469,918944,163376,810518,325939,711500,789211,169275,772829,466586,379105,659847,69977,237282,1028191,98138,604483,862572,395232) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]