SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502207 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502207 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694076,131893,726081,26518,507946,631998,157963,1005564,1041194,19883,275505,901844,191797,94369,885865,716517,752086,79295,952331,195687,583812,320030,386097,802602,403167,72401,447503,992515,864693,792499,862453,855480,651595,1048734,925520,567999,635308,720623,937128,628574,592717,733239,1012021,73679,71959,655876,121367,515568,373354,3078,132342,351825,916427,220307,857199,28702,279576,271268,297855,16188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002289s ]