SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 754511 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 754511 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (610327,258300,659816,470542,466485,850528,200991,530230,1014531,800485,1038896,1009259,999759,635101,137938,992541,164913,380082,663991,332647,74942,175543,768736,1009856,914125,302384,410828,291610,962435,253184,840595,78929,812141,580482,718190,632612,466345,729440,811749,474119,617070,55310,908594,497575,466494,711961,651071,287601,880946,840099,899554,783116,79724,11150,117398,685170,714706,423253,747557,500543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 754511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 754511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]