SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291215 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291215 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327798,382268,547463,521625,715549,966339,265820,1042840,988794,249571,563441,247399,752094,981547,1035036,881900,1289,230851,861145,665759,36316,606127,386163,934553,489630,520427,827898,718077,170021,811122,229154,574284,900234,394576,74181,1048224,679259,434523,166043,518956,804419,109705,333320,930810,540841,136226,557938,918298,348077,956542,484882,890017,422513,998203,472496,217070,142113,974281,788486,1039898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]