SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037502 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037502 [ RunTime:0.001962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34051,421065,475338,497953,912637,281370,680836,483416,36121,944625,734076,1019586,925697,336671,81655,1025497,227172,219687,122380,300143,608218,277609,527255,629168,702634,573952,182877,485233,906783,467478,683511,985262,770161,1024547,139660,884013,978530,729575,337237,185346,439213,333373,848338,245078,780434,717485,982912,693335,143827,653646,989630,1037880,211116,392584,828289,878856,303901,214730,634873,177945) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037502 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037502 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]