SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001586s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043228 LIMIT 1 [ RunTime:0.000718s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043228 [ RunTime:0.002380s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182775,257576,651916,365936,359982,582958,140484,666308,851210,861103,928686,283487,937172,285845,932090,742262,315804,453794,39787,157074,719250,97012,1018071,674610,644002,336960,725058,319560,426182,7897,350959,608225,1034893,448938,757651,821161,519682,319873,291374,814047,228912,778208,853729,124715,434480,912134,47645,99637,771305,484230,475664,43364,606019,899017,574547,544917,715831,539119,55212,89877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000761s ]